package com.neusoft.mapper;

import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import com.neusoft.po.Food;

@Mapper
public interface FoodMapper {
 @Select("select * from food where businessId=#{businessId} order by foodId")
 public List<Food> listFoodByBusinessId(Integer businessId);
 
 @Select("select * from food where foodId=#{foodId}")
 public Food getFoodById(Integer foodId);
 
 //for search
 //@Select("select * from food where foodName like CONCAT('%',#{foodName},'%')")
 //public List<Food> searchFood(String foodName);
 
}